DECLARE @SalesPersonID	int 
DECLARE @EmployeeID	int 
DECLARE @Territory	nvarchar (50)
DECLARE @Manager	nvarchar (15)
DECLARE @Contact	nvarchar (50)
DECLARE @SalesQuota	money
DECLARE @Bonus	money
DECLARE @CommissionPct	smallmoney
DECLARE @SalesYTD	money
DECLARE @SalesLastYear	money
DECLARE @rowguid	uniqueidentifier
DECLARE @ModifiedDate	datetime
DECLARE @NationalIDNumber	nvarchar (15)
DECLARE @LoginID	nvarchar (256)
DECLARE @Title	nvarchar (50)
DECLARE @BirthDate	datetime
DECLARE @MaritalStatus	nchar (1)
DECLARE @Gender	nchar (1)
DECLARE @HireDate	datetime
DECLARE @SalariedFlag	bit
DECLARE @VacationHours	smallint
DECLARE @SickLeaveHours	smallint
DECLARE @CurrentFlag	bit

--SET @SalesPersonID = 318
SET @Territory = 'Northeast'
SET @Manager = '480168528'
SET @Contact = 'kim2@adventure-works.com'
SET @SalesQuota = '10'
SET @Bonus = '30'
SET @CommissionPct = '20'
SET @SalesYTD = '1000'
SET @SalesLastYear = '2000'
SET @rowguid = '6F9619FF-8B86-D011-B42D-00C04FC964FB'
SET @ModifiedDate = '2008-01-01'
SET @NationalIDNumber = '280169999'
SET @LoginID = 'adventure-works\test1'
SET @Title = 'Mr'
SET @BirthDate = '1970-01-01'
SET @MaritalStatus = 'S'
SET @Gender = 'M'
SET @HireDate = '2008-01-01'
SET @SalariedFlag = '1'
SET @VacationHours = '10'
SET @SickLeaveHours = '20'
SET @CurrentFlag = '1'

exec gsp_SalesPersonStore @SalesPersonID, @Territory, @Manager, @Contact, @SalesQuota, @Bonus, @CommissionPct, @SalesYTD, @SalesLastYear, @rowguid, @ModifiedDate, @NationalIDNumber, @LoginID, @Title, @BirthDate, @MaritalStatus, @Gender, @HireDate, @SalariedFlag, @VacationHours, @SickLeaveHours, @CurrentFlag
PRINT @SalesPersonID
